Covid-19 Status in The United States of America

Introduction


This analysis is done using “covdata” package in RStudio and the data used in the analysis is contained in the data sets; “covus”, “covus_ethnicity”, “uspop” and “nchs_wdc” . Through this analysis we are determined to get an understanding about how the Covid-19 pandemic has impacted each state, each ethnicity group and each race living in The United States of America.


How positive cases, deaths and recoveries occured within States


Figure 1: Heatmap of Cumulative Positive Cases, Cumulative Deaths and Cumulative Recoveries by State from 2020/01/13 to 2021/07/03


During the analysis to avoid the scale difference the counts have been recalculated as the natural logarithm values. In the above interactive heat map, the heat map corresponding to death counts indicates that the very first death in The USA have occurred on 24th February 2020 in Washington DC the capital of US. Throughout the time period considered in the study New York, New Jersey, California and Texas has reported high number of Cumulative deaths. According to the heat map of cumulative positive cases the very first positive case was recorded in Washington DC on 19th January 2020. However the other states has recorded cases with a lag of about one month according to this data set. We can observe that California, Georgia, Florida, New York and Texas have comparatively high counts of cumulative positive cases throughout the study period. The heat map of recoveries indicates that the total recoveries have increased in the latter part of the study period.



How the Health Care system of The USA is handelling Covid-19


Figure 2: The Density map of Hospitalized people, People in the ICU and people on Ventilator Machines


The above Figure depicts how the patients hospitalized are getting treated in each state. With a quick glance we can see that states, Alabama, Colorado, Connecticut, Florida, Georgia, Nebraska, New Hampshire, New Mexico and Wyoming has not recorded critical patients according to data. This might be probably because of lack of records on treatment data in those states. It can be identified that in most states the proportion of people relying on ICU and Ventilators are quite high.



How Ethnicities are Impacted by Covid-19

Figure 3 : Boxplots of Cases by Ethnicity and Deaths by Ethnicity in USA

  Hispanic_pop Not.Hispanic_pop
1     59871746        534591376


According to “uspop” data set the Hispanic and Non Hispanic population counts are shown in Result 1. Therefore Non Hispanic population is very high compared to Hispanic population in the US. According to Figure 3 both cases and deaths are recorded highly among Non Hispanic population. The huge difference in population counts might be the cause of this. The average number of 273936 covid-19 cases and an average number of 7989 covid deaths are reported among Non Hispanic people.


Causes of Deaths in US and significance of Covid-19 Deaths Numbers

Figure 4 : Bar Graph of Deaths by Causes of Death in USA 2020-2021


Figure 4 shows the major causes of death among citizens of The United States of America. In 2020 total number of deaths due to all causes in the USA is 3,440,703 and in 2021 it is 2,018,454.It can be seen that the covid-19 has become the 4th highest contributing factor for the total deaths among American Citizens with 392,359 deaths in 2020 and 238,979 deaths in 2021 so far.